<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'MyJsp.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

</head>

<body>
	<%
		Map<String, String> map = new HashMap<String, String>();
		map.put("wo", "三生三世");
		map.put("shi", "sedf");
		map.put("shui", "wewrfd");
		map.put("a", "dsfsdfs");
		request.setAttribute("map", map);
	%>
	<c:forEach items="${map }" var="map" varStatus="vs">
<span<c:if test="${vs.index%2==1 }">
	style="background-color:red;"
	</c:if>>
	${map.key }--${map.value}</span><br>
	</c:forEach>
	
	<sql:setDataSource var="nd" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/newsmanagersystem?useUnicode=true&characterEncoding=utf8" user="root" password="2129"/>
	<sql:query var="top" dataSource="${nd }">
	SELECT * FROM topic
	</sql:query>
	<table border="1">
	<c:forEach items="${top.rows }" var="t">
	<tr>
	<td>${t.tid }</td>
	<td>${t.tname}</td>
	</tr>
	</c:forEach>
	</table>
</body>
</html>
